Permissions

The user specified in the endpoint settings must be granted access to the Netezza Performance Server (NPS) account as well as the privileges listed below.

Database privileges

• LIST on <database> to <Replicate user>
• SELECT on <database> to <Replicate user>

Table privileges

• CREATE TABLE to <Replicate user>
• LIST on TABLE to <Replicate user>

Schema privileges

• CREATE SCHEMA to <Replicate user>
• LIST on SCHEMA to <Replicate user>

View privileges

• SELECT on _T_DATABASE to <Replicate user>
• SELECT on _V_SCHEMA to <Replicate user>
• SELECT on _V_USER to <Replicate user>
• SELECT on _V_TABLE to <Replicate user>
• SELECT on _V_TABLE_DIST to <Replicate user>
• SELECT on _V_RELATION_KEYDATA to <Replicate user>
• LIST on _T_DATABASE to <Replicate user>
• LIST on _V_SCHEMA to <Replicate user>
• LIST on _V_USER to <Replicate user>
• LIST on _V_TABLE to <Replicate user>
• LIST on _V_TABLE_DIST to <Replicate user>
• LIST on _V_RELATION_KEYDATA to <Replicate user>